CREATE external TABLE jms_ods.TAB_FORFEIT_REJECTED_CONFIG(
ID string                   COMMENT '主键ID'
,FEE_NAME string            COMMENT  '奖罚名称'
,FEE_MENU string            COMMENT  '奖罚菜单'
,CENTER_CODE string                COMMENT '机构编码'
,CENTER_NAME string                COMMENT '机构秘境车'
,FEE_NUMBER bigint            COMMENT  '剔除票数'
,FEE_date date                      COMMENT '费用计算时间'
,CREATE_TIME date                   COMMENT  '创建时间'
,CREATE_BY_NAME string      COMMENT  '创建人'
,CREATE_BY_CODE string      COMMENT  '创建人编码'
,UPdate_TIME date                   COMMENT  '更新时间'
,UPdate_BY_NAME string      COMMENT '更新人'
,UPdate_BY_CODE string      COMMENT  '更新人编码'
) comment '剔除票数配置'
PARTITIONED BY (
 dt string COMMENT '时间分区')
 ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_ods.db/external/tab_forfeit_rejected_config'